﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using BaseData;
using BaseData.Common;

namespace TaxData.Tax
{
    /// <summary>
    /// 税收统计
    /// </summary>
    public class TaxTongjiData
    { 
         /// <summary>
         /// 获取税收统计记录
         /// </summary>
        public static DataTable GetList(int yearMin, int yearMax, int departmentID)
        {
            SqlParameter p1 = new SqlParameter("@yearMin", SqlDbType.VarChar, 10);
            p1.Value = yearMin;
            SqlParameter p2 = new SqlParameter("@yearMax", SqlDbType.VarChar, 10);
            p2.Value = yearMax;
            SqlParameter p3 = new SqlParameter("@departmentID", SqlDbType.Int, 8);
            p3.Value = departmentID;
            DataTable dt = DataConfig.QueryRecordsByStoredProcedure(BusinessType.DBWrite, "GetTaxTongji", p1, p2, p3);
            return dt;
        }
    }
}
